COUNTNIF

Counts the number of cells that do NOT meet a specified condition.

Syntax

COUNTNIF(range, criteria)

Arguments

• range: The range of cells to count.
• criteria: The condition that defines which cells to exclude from the count.

Example

COUNTNIF(A1:A10, ">20") → Counts cells in range A1:A10 with values NOT greater than 20
COUNTNIF(B1:B10, "Completed") → Counts cells in range B1:B10 that do NOT contain "Completed"